package com.erp.app.common.query;

import com.erp.app.admin.userSetup.pk.UserPk;

public class SignatureQuery extends BeanQuery {
	public SignatureQuery() {
        super(	" SELECT USER_CODE, USER_NAME FROM T_USER WHERE "
        		+ " COMPANY_CODE = `companyCode:string` "
        		+ " AND (ACTIVATION = `$GENERIC_ACTIVE:string` "
        		+ "       OR USER_CODE = `userCode:string`) "
        		+ " AND (ROLE_GROUP_ID ='FM' OR ROLE_GROUP_ID ='FS')"
        		+ " ORDER BY USER_NAME ");
   }

   public SignatureQuery setUserPk(UserPk userPk) {
       this.setModel(userPk);
       return this;	
   }

   public SignatureQuery setCompanyCode(String companyCode) {
       return this.setUserPk(new UserPk(companyCode, null));
   }

}
